{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "█\r"
     ]
    }
   ],
   "source": [
    "from setting import get_engine\n",
    "from setting import get_mysql_conn\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime\n",
    "from collections import OrderedDict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "明泰转债 99.94\n",
      "迪森转债 99.888\n",
      "亨通转债 98.76\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\pymysql\\cursors.py:170: Warning: (1366, \"Incorrect string value: '\\\\xD6\\\\xD0\\\\xB9\\\\xFA\\\\xB1\\\\xEA...' for column 'VARIABLE_VALUE' at row 480\")\n",
      "  result = self._query(query)\n"
     ]
    }
   ],
   "source": [
    "# 找出可转债价格低于100但是我还没有买的\n",
    "def find_low_not_buy(position_table):\n",
    "    con1=get_engine('db_position')\n",
    "\n",
    "    df1 = pd.read_sql(position_table,con=con1)\n",
    "    con2=get_engine('db_stock')\n",
    "    df2 = pd.read_sql('tb_bond_jisilu',con=con2)\n",
    "    df_low = df2[df2['可转债价格']<100]\n",
    "    my_code = list(df1['证券代码'].values)\n",
    "    print('低于100但是我还没有买的')\n",
    "    for idx,row in df_low.iterrows():\n",
    "        if row['可转债代码'] not in my_code:\n",
    "            \n",
    "            print(row['可转债名称'],row['可转债价格'])\n",
    "            \n",
    "\n",
    "position_table='tb_position_2019-06-30'\n",
    "find_low_not_buy(position_table)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "可转债价格中位数：105.37\n",
      "可转债价格平均数：109.61\n",
      "可转债价格方差：17.04\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\pymysql\\cursors.py:170: Warning: (1366, \"Incorrect string value: '\\\\xD6\\\\xD0\\\\xB9\\\\xFA\\\\xB1\\\\xEA...' for column 'VARIABLE_VALUE' at row 480\")\n",
      "  result = self._query(query)\n"
     ]
    }
   ],
   "source": [
    "# 当前可转债的中位数\n",
    "def calculation(table_name='tb_bond_jisilu'):\n",
    "    con2=get_engine('db_stock')\n",
    "    df2 = pd.read_sql(table_name,con=con2)\n",
    "    m=df2['可转债价格'].median()\n",
    "    m=round(m,2)\n",
    "    print('可转债价格中位数：{}'.format(m))\n",
    "    \n",
    "    mean=df2['可转债价格'].mean()\n",
    "    \n",
    "    mean=round(mean,2)\n",
    "    print('可转债价格平均数：{}'.format(mean))\n",
    "    \n",
    "    std=df2['可转债价格'].std()\n",
    "    \n",
    "    std=round(std,2)\n",
    "    print('可转债价格方差：{}'.format(std))\n",
    "    \n",
    "calculation()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 测试一下那个方差\n",
    "x=[1,2,3,4,5,6,7,8,9,10]\n",
    "X = np.array(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5.5"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X.mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2.8722813232690143"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X.std() # 标准差"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "8.25"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X.var() # 方差"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [],
   "source": [
    "def my_fangca(X):\n",
    "    l=len(X)\n",
    "    mean=X.mean()\n",
    "    sum_ = 0\n",
    "    sum_std=0\n",
    "    for i in X:\n",
    "        sum_+=(i-mean)**2\n",
    "    var_=sum_/l\n",
    "    std_=(sum_/(l))**0.5\n",
    "    return var_,std_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = my_fangca(X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(8.25, 2.8722813232690143)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/xda/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py:170: Warning: (1366, \"Incorrect string value: '\\\\xD6\\\\xD0\\\\xB9\\\\xFA\\\\xB1\\\\xEA...' for column 'VARIABLE_VALUE' at row 480\")\n",
      "  result = self._query(query)\n"
     ]
    }
   ],
   "source": [
    "# tb_jsl_2019-06-26\n",
    "d='2019-06-26'\n",
    "con = get_engine('db_jisilu',local='local')\n",
    "df = pd.read_sql('tb_jsl_{}'.format(d),con=con)\n",
    "df=df[df['可转债价格']>0] # 去除停牌\n",
    "\n",
    "ret = df['可转债价格'].std()\n",
    "\n",
    "# def get_daily_std(df=None):\n",
    "#     print()\n",
    "    \n",
    "# get_daily_std(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>可转债代码</th>\n",
       "      <th>可转债名称</th>\n",
       "      <th>可转债价格</th>\n",
       "      <th>正股名称</th>\n",
       "      <th>正股代码</th>\n",
       "      <th>正股现价</th>\n",
       "      <th>正股涨跌幅</th>\n",
       "      <th>最新转股价</th>\n",
       "      <th>溢价率</th>\n",
       "      <th>可转债涨幅</th>\n",
       "      <th>...</th>\n",
       "      <th>剩余时间</th>\n",
       "      <th>回售起始日</th>\n",
       "      <th>评级</th>\n",
       "      <th>下修提示</th>\n",
       "      <th>下调次数</th>\n",
       "      <th>转债剩余占总市值比</th>\n",
       "      <th>剩余规模</th>\n",
       "      <th>发行规模</th>\n",
       "      <th>股东配售率</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>127009</td>\n",
       "      <td>冰轮转债</td>\n",
       "      <td>145.750</td>\n",
       "      <td>冰轮环境</td>\n",
       "      <td>000811</td>\n",
       "      <td>8.89</td>\n",
       "      <td>-5.12</td>\n",
       "      <td>5.52</td>\n",
       "      <td>-9.50</td>\n",
       "      <td>-2.54</td>\n",
       "      <td>...</td>\n",
       "      <td>5.559</td>\n",
       "      <td>2023-01-14</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>8.8</td>\n",
       "      <td>5.091</td>\n",
       "      <td>5.091</td>\n",
       "      <td>44.230</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>110052</td>\n",
       "      <td>贵广转债</td>\n",
       "      <td>118.080</td>\n",
       "      <td>贵广网络</td>\n",
       "      <td>600996</td>\n",
       "      <td>10.44</td>\n",
       "      <td>3.57</td>\n",
       "      <td>8.13</td>\n",
       "      <td>-8.04</td>\n",
       "      <td>1.23</td>\n",
       "      <td>...</td>\n",
       "      <td>5.696</td>\n",
       "      <td>2023-03-05</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>14.7</td>\n",
       "      <td>16.000</td>\n",
       "      <td>16.000</td>\n",
       "      <td>32.835</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>113526</td>\n",
       "      <td>联泰转债</td>\n",
       "      <td>119.170</td>\n",
       "      <td>联泰环保</td>\n",
       "      <td>603797</td>\n",
       "      <td>11.20</td>\n",
       "      <td>1.63</td>\n",
       "      <td>8.72</td>\n",
       "      <td>-7.22</td>\n",
       "      <td>1.15</td>\n",
       "      <td>...</td>\n",
       "      <td>5.581</td>\n",
       "      <td>2023-01-23</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>11.7</td>\n",
       "      <td>3.900</td>\n",
       "      <td>3.900</td>\n",
       "      <td>77.340</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>113529</td>\n",
       "      <td>绝味转债</td>\n",
       "      <td>127.770</td>\n",
       "      <td>绝味食品</td>\n",
       "      <td>603517</td>\n",
       "      <td>38.35</td>\n",
       "      <td>4.35</td>\n",
       "      <td>28.51</td>\n",
       "      <td>-5.01</td>\n",
       "      <td>2.95</td>\n",
       "      <td>...</td>\n",
       "      <td>5.712</td>\n",
       "      <td>2023-03-11</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>10.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td>55.430</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>128052</td>\n",
       "      <td>凯龙转债</td>\n",
       "      <td>184.900</td>\n",
       "      <td>凯龙股份</td>\n",
       "      <td>002783</td>\n",
       "      <td>12.83</td>\n",
       "      <td>-3.39</td>\n",
       "      <td>6.77</td>\n",
       "      <td>-2.43</td>\n",
       "      <td>-1.75</td>\n",
       "      <td>...</td>\n",
       "      <td>5.493</td>\n",
       "      <td>2022-12-21</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>7.7</td>\n",
       "      <td>3.289</td>\n",
       "      <td>3.289</td>\n",
       "      <td>19.050</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>113533</td>\n",
       "      <td>参林转债</td>\n",
       "      <td>119.000</td>\n",
       "      <td>大参林</td>\n",
       "      <td>603233</td>\n",
       "      <td>44.00</td>\n",
       "      <td>5.19</td>\n",
       "      <td>36.50</td>\n",
       "      <td>-1.29</td>\n",
       "      <td>1.87</td>\n",
       "      <td>...</td>\n",
       "      <td>5.773</td>\n",
       "      <td>2023-04-03</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>10.000</td>\n",
       "      <td>10.000</td>\n",
       "      <td>40.200</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>113507</td>\n",
       "      <td>天马转债</td>\n",
       "      <td>121.470</td>\n",
       "      <td>天马科技</td>\n",
       "      <td>603668</td>\n",
       "      <td>8.98</td>\n",
       "      <td>-1.97</td>\n",
       "      <td>7.32</td>\n",
       "      <td>-0.99</td>\n",
       "      <td>-1.47</td>\n",
       "      <td>...</td>\n",
       "      <td>4.814</td>\n",
       "      <td>2022-04-17</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.599</td>\n",
       "      <td>3.050</td>\n",
       "      <td>32.260</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>113511</td>\n",
       "      <td>千禾转债</td>\n",
       "      <td>121.230</td>\n",
       "      <td>千禾味业</td>\n",
       "      <td>603027</td>\n",
       "      <td>22.38</td>\n",
       "      <td>3.47</td>\n",
       "      <td>18.31</td>\n",
       "      <td>-0.82</td>\n",
       "      <td>3.74</td>\n",
       "      <td>...</td>\n",
       "      <td>4.986</td>\n",
       "      <td>2022-06-20</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>3.4</td>\n",
       "      <td>3.500</td>\n",
       "      <td>3.560</td>\n",
       "      <td>11.540</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>113523</td>\n",
       "      <td>伟明转债</td>\n",
       "      <td>125.620</td>\n",
       "      <td>伟明环保</td>\n",
       "      <td>603568</td>\n",
       "      <td>22.03</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>17.47</td>\n",
       "      <td>-0.38</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>...</td>\n",
       "      <td>5.463</td>\n",
       "      <td>2022-12-10</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>5.347</td>\n",
       "      <td>6.700</td>\n",
       "      <td>83.350</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>110040</td>\n",
       "      <td>生益转债</td>\n",
       "      <td>128.900</td>\n",
       "      <td>生益科技</td>\n",
       "      <td>600183</td>\n",
       "      <td>14.57</td>\n",
       "      <td>3.19</td>\n",
       "      <td>11.27</td>\n",
       "      <td>-0.29</td>\n",
       "      <td>2.83</td>\n",
       "      <td>...</td>\n",
       "      <td>4.414</td>\n",
       "      <td>None</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>4.8</td>\n",
       "      <td>14.812</td>\n",
       "      <td>18.000</td>\n",
       "      <td>81.241</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>110050</td>\n",
       "      <td>佳都转债</td>\n",
       "      <td>125.830</td>\n",
       "      <td>佳都科技</td>\n",
       "      <td>600728</td>\n",
       "      <td>9.94</td>\n",
       "      <td>-1.19</td>\n",
       "      <td>7.89</td>\n",
       "      <td>-0.12</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>...</td>\n",
       "      <td>5.485</td>\n",
       "      <td>2022-12-19</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5.4</td>\n",
       "      <td>8.747</td>\n",
       "      <td>8.747</td>\n",
       "      <td>14.080</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>113505</td>\n",
       "      <td>杭电转债</td>\n",
       "      <td>108.730</td>\n",
       "      <td>杭电股份</td>\n",
       "      <td>603618</td>\n",
       "      <td>7.88</td>\n",
       "      <td>-1.13</td>\n",
       "      <td>7.24</td>\n",
       "      <td>-0.10</td>\n",
       "      <td>0.06</td>\n",
       "      <td>...</td>\n",
       "      <td>4.696</td>\n",
       "      <td>2022-03-06</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>14.3</td>\n",
       "      <td>7.767</td>\n",
       "      <td>7.800</td>\n",
       "      <td>20.430</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>128038</td>\n",
       "      <td>利欧转债</td>\n",
       "      <td>113.945</td>\n",
       "      <td>利欧股份</td>\n",
       "      <td>002131</td>\n",
       "      <td>1.96</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.72</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.23</td>\n",
       "      <td>...</td>\n",
       "      <td>4.742</td>\n",
       "      <td>2022-03-22</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.811</td>\n",
       "      <td>21.975</td>\n",
       "      <td>26.480</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>128024</td>\n",
       "      <td>宁行转债</td>\n",
       "      <td>131.100</td>\n",
       "      <td>宁波银行</td>\n",
       "      <td>002142</td>\n",
       "      <td>23.61</td>\n",
       "      <td>-0.25</td>\n",
       "      <td>18.01</td>\n",
       "      <td>0.01</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>...</td>\n",
       "      <td>4.447</td>\n",
       "      <td>None</td>\n",
       "      <td>AAA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>49.060</td>\n",
       "      <td>100.000</td>\n",
       "      <td>79.110</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>123018</td>\n",
       "      <td>溢利转债</td>\n",
       "      <td>107.778</td>\n",
       "      <td>溢多利</td>\n",
       "      <td>300381</td>\n",
       "      <td>8.97</td>\n",
       "      <td>-2.29</td>\n",
       "      <td>8.35</td>\n",
       "      <td>0.32</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>...</td>\n",
       "      <td>5.490</td>\n",
       "      <td>2022-12-20</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>18.2</td>\n",
       "      <td>6.650</td>\n",
       "      <td>6.650</td>\n",
       "      <td>35.630</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>113513</td>\n",
       "      <td>安井转债</td>\n",
       "      <td>148.010</td>\n",
       "      <td>安井食品</td>\n",
       "      <td>603345</td>\n",
       "      <td>51.67</td>\n",
       "      <td>3.76</td>\n",
       "      <td>35.08</td>\n",
       "      <td>0.49</td>\n",
       "      <td>4.63</td>\n",
       "      <td>...</td>\n",
       "      <td>5.049</td>\n",
       "      <td>2022-07-12</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.145</td>\n",
       "      <td>5.000</td>\n",
       "      <td>56.760</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>128041</td>\n",
       "      <td>盛路转债</td>\n",
       "      <td>143.499</td>\n",
       "      <td>盛路通信</td>\n",
       "      <td>002446</td>\n",
       "      <td>9.81</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>6.88</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.06</td>\n",
       "      <td>...</td>\n",
       "      <td>5.060</td>\n",
       "      <td>2022-07-17</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.871</td>\n",
       "      <td>10.000</td>\n",
       "      <td>13.900</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>113520</td>\n",
       "      <td>百合转债</td>\n",
       "      <td>119.720</td>\n",
       "      <td>梦百合</td>\n",
       "      <td>603313</td>\n",
       "      <td>16.96</td>\n",
       "      <td>1.68</td>\n",
       "      <td>14.28</td>\n",
       "      <td>0.80</td>\n",
       "      <td>1.18</td>\n",
       "      <td>...</td>\n",
       "      <td>5.375</td>\n",
       "      <td>2022-11-08</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>7.8</td>\n",
       "      <td>4.236</td>\n",
       "      <td>5.100</td>\n",
       "      <td>56.660</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>113020</td>\n",
       "      <td>桐昆转债</td>\n",
       "      <td>116.800</td>\n",
       "      <td>桐昆股份</td>\n",
       "      <td>601233</td>\n",
       "      <td>14.45</td>\n",
       "      <td>1.33</td>\n",
       "      <td>12.51</td>\n",
       "      <td>1.12</td>\n",
       "      <td>2.18</td>\n",
       "      <td>...</td>\n",
       "      <td>5.405</td>\n",
       "      <td>2022-11-19</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>14.4</td>\n",
       "      <td>37.806</td>\n",
       "      <td>38.000</td>\n",
       "      <td>43.250</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>110046</td>\n",
       "      <td>圆通转债</td>\n",
       "      <td>116.190</td>\n",
       "      <td>圆通速递</td>\n",
       "      <td>600233</td>\n",
       "      <td>12.33</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>10.74</td>\n",
       "      <td>1.21</td>\n",
       "      <td>0.11</td>\n",
       "      <td>...</td>\n",
       "      <td>5.405</td>\n",
       "      <td>2022-11-20</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>10.4</td>\n",
       "      <td>36.241</td>\n",
       "      <td>36.500</td>\n",
       "      <td>39.350</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>123016</td>\n",
       "      <td>洲明转债</td>\n",
       "      <td>120.000</td>\n",
       "      <td>洲明科技</td>\n",
       "      <td>300232</td>\n",
       "      <td>9.27</td>\n",
       "      <td>0.32</td>\n",
       "      <td>7.82</td>\n",
       "      <td>1.23</td>\n",
       "      <td>0.67</td>\n",
       "      <td>...</td>\n",
       "      <td>5.373</td>\n",
       "      <td>2022-11-07</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>6.1</td>\n",
       "      <td>5.200</td>\n",
       "      <td>5.480</td>\n",
       "      <td>33.980</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>110049</td>\n",
       "      <td>海尔转债</td>\n",
       "      <td>120.750</td>\n",
       "      <td>青岛海尔</td>\n",
       "      <td>600690</td>\n",
       "      <td>17.27</td>\n",
       "      <td>1.71</td>\n",
       "      <td>14.55</td>\n",
       "      <td>1.74</td>\n",
       "      <td>1.45</td>\n",
       "      <td>...</td>\n",
       "      <td>5.482</td>\n",
       "      <td>2022-12-18</td>\n",
       "      <td>AAA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>30.075</td>\n",
       "      <td>30.075</td>\n",
       "      <td>60.100</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>113515</td>\n",
       "      <td>高能转债</td>\n",
       "      <td>116.250</td>\n",
       "      <td>高能环境</td>\n",
       "      <td>603588</td>\n",
       "      <td>10.65</td>\n",
       "      <td>-1.84</td>\n",
       "      <td>9.33</td>\n",
       "      <td>1.84</td>\n",
       "      <td>-0.57</td>\n",
       "      <td>...</td>\n",
       "      <td>5.088</td>\n",
       "      <td>2022-07-26</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>9.9</td>\n",
       "      <td>7.093</td>\n",
       "      <td>8.400</td>\n",
       "      <td>46.740</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>128057</td>\n",
       "      <td>博彦转债</td>\n",
       "      <td>106.064</td>\n",
       "      <td>博彦科技</td>\n",
       "      <td>002649</td>\n",
       "      <td>9.15</td>\n",
       "      <td>0.66</td>\n",
       "      <td>8.81</td>\n",
       "      <td>2.12</td>\n",
       "      <td>0.40</td>\n",
       "      <td>...</td>\n",
       "      <td>5.696</td>\n",
       "      <td>2023-03-05</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5.758</td>\n",
       "      <td>5.758</td>\n",
       "      <td>16.060</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>128060</td>\n",
       "      <td>中装转债</td>\n",
       "      <td>101.807</td>\n",
       "      <td>中装建设</td>\n",
       "      <td>002822</td>\n",
       "      <td>6.22</td>\n",
       "      <td>-1.58</td>\n",
       "      <td>6.24</td>\n",
       "      <td>2.13</td>\n",
       "      <td>0.10</td>\n",
       "      <td>...</td>\n",
       "      <td>5.753</td>\n",
       "      <td>2023-03-27</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>14.1</td>\n",
       "      <td>5.250</td>\n",
       "      <td>5.250</td>\n",
       "      <td>32.910</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>127003</td>\n",
       "      <td>海印转债</td>\n",
       "      <td>103.530</td>\n",
       "      <td>海印股份</td>\n",
       "      <td>000861</td>\n",
       "      <td>3.07</td>\n",
       "      <td>-9.97</td>\n",
       "      <td>3.03</td>\n",
       "      <td>2.18</td>\n",
       "      <td>-5.54</td>\n",
       "      <td>...</td>\n",
       "      <td>2.953</td>\n",
       "      <td>2020-06-08</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>2</td>\n",
       "      <td>14.1</td>\n",
       "      <td>9.416</td>\n",
       "      <td>11.110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>127007</td>\n",
       "      <td>湖广转债</td>\n",
       "      <td>110.200</td>\n",
       "      <td>湖北广电</td>\n",
       "      <td>000665</td>\n",
       "      <td>8.54</td>\n",
       "      <td>0.12</td>\n",
       "      <td>7.92</td>\n",
       "      <td>2.20</td>\n",
       "      <td>0.49</td>\n",
       "      <td>...</td>\n",
       "      <td>5.011</td>\n",
       "      <td>2022-06-28</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>22.7</td>\n",
       "      <td>13.214</td>\n",
       "      <td>17.336</td>\n",
       "      <td>16.550</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>113536</td>\n",
       "      <td>三星转债</td>\n",
       "      <td>102.080</td>\n",
       "      <td>三星新材</td>\n",
       "      <td>603578</td>\n",
       "      <td>19.69</td>\n",
       "      <td>0.15</td>\n",
       "      <td>19.75</td>\n",
       "      <td>2.39</td>\n",
       "      <td>0.37</td>\n",
       "      <td>...</td>\n",
       "      <td>5.932</td>\n",
       "      <td>2023-05-31</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>10.9</td>\n",
       "      <td>1.920</td>\n",
       "      <td>1.920</td>\n",
       "      <td>35.470</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>128025</td>\n",
       "      <td>特一转债</td>\n",
       "      <td>109.778</td>\n",
       "      <td>特一药业</td>\n",
       "      <td>002728</td>\n",
       "      <td>16.56</td>\n",
       "      <td>-0.36</td>\n",
       "      <td>15.45</td>\n",
       "      <td>2.42</td>\n",
       "      <td>0.25</td>\n",
       "      <td>...</td>\n",
       "      <td>4.449</td>\n",
       "      <td>2021-12-06</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>10.2</td>\n",
       "      <td>3.394</td>\n",
       "      <td>3.540</td>\n",
       "      <td>74.250</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>128062</td>\n",
       "      <td>亚药转债</td>\n",
       "      <td>102.250</td>\n",
       "      <td>亚太药业</td>\n",
       "      <td>002370</td>\n",
       "      <td>16.17</td>\n",
       "      <td>0.31</td>\n",
       "      <td>16.25</td>\n",
       "      <td>2.75</td>\n",
       "      <td>-0.32</td>\n",
       "      <td>...</td>\n",
       "      <td>5.773</td>\n",
       "      <td>2023-04-03</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>11.1</td>\n",
       "      <td>9.650</td>\n",
       "      <td>9.650</td>\n",
       "      <td>29.780</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>113021</td>\n",
       "      <td>中信转债</td>\n",
       "      <td>103.780</td>\n",
       "      <td>中信银行</td>\n",
       "      <td>601998</td>\n",
       "      <td>5.98</td>\n",
       "      <td>0.17</td>\n",
       "      <td>7.45</td>\n",
       "      <td>29.29</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>...</td>\n",
       "      <td>5.690</td>\n",
       "      <td>None</td>\n",
       "      <td>AAA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>13.7</td>\n",
       "      <td>400.000</td>\n",
       "      <td>400.000</td>\n",
       "      <td>73.880</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>113530</td>\n",
       "      <td>大丰转债</td>\n",
       "      <td>97.770</td>\n",
       "      <td>大丰实业</td>\n",
       "      <td>603081</td>\n",
       "      <td>12.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16.76</td>\n",
       "      <td>30.05</td>\n",
       "      <td>0.32</td>\n",
       "      <td>...</td>\n",
       "      <td>5.753</td>\n",
       "      <td>2023-03-27</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>12.4</td>\n",
       "      <td>6.300</td>\n",
       "      <td>6.300</td>\n",
       "      <td>23.030</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>128017</td>\n",
       "      <td>金禾转债</td>\n",
       "      <td>105.800</td>\n",
       "      <td>金禾实业</td>\n",
       "      <td>002597</td>\n",
       "      <td>18.63</td>\n",
       "      <td>0.32</td>\n",
       "      <td>22.96</td>\n",
       "      <td>30.39</td>\n",
       "      <td>-0.19</td>\n",
       "      <td>...</td>\n",
       "      <td>4.353</td>\n",
       "      <td>2022-11-01</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5.8</td>\n",
       "      <td>6.000</td>\n",
       "      <td>6.000</td>\n",
       "      <td>89.139</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>113508</td>\n",
       "      <td>新凤转债</td>\n",
       "      <td>99.390</td>\n",
       "      <td>新凤鸣</td>\n",
       "      <td>603225</td>\n",
       "      <td>12.69</td>\n",
       "      <td>0.71</td>\n",
       "      <td>16.83</td>\n",
       "      <td>31.82</td>\n",
       "      <td>0.39</td>\n",
       "      <td>...</td>\n",
       "      <td>4.836</td>\n",
       "      <td>2022-04-26</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>14.2</td>\n",
       "      <td>21.524</td>\n",
       "      <td>21.530</td>\n",
       "      <td>36.950</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>110045</td>\n",
       "      <td>海澜转债</td>\n",
       "      <td>98.250</td>\n",
       "      <td>海澜之家</td>\n",
       "      <td>600398</td>\n",
       "      <td>8.91</td>\n",
       "      <td>1.02</td>\n",
       "      <td>12.02</td>\n",
       "      <td>32.54</td>\n",
       "      <td>-0.28</td>\n",
       "      <td>...</td>\n",
       "      <td>5.052</td>\n",
       "      <td>2022-07-13</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>29.994</td>\n",
       "      <td>30.000</td>\n",
       "      <td>54.100</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>123017</td>\n",
       "      <td>寒锐转债</td>\n",
       "      <td>96.720</td>\n",
       "      <td>寒锐钴业</td>\n",
       "      <td>300618</td>\n",
       "      <td>59.29</td>\n",
       "      <td>-0.60</td>\n",
       "      <td>81.49</td>\n",
       "      <td>32.93</td>\n",
       "      <td>-0.18</td>\n",
       "      <td>...</td>\n",
       "      <td>5.408</td>\n",
       "      <td>2022-11-20</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>4.400</td>\n",
       "      <td>4.400</td>\n",
       "      <td>5.510</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>128051</td>\n",
       "      <td>光华转债</td>\n",
       "      <td>98.001</td>\n",
       "      <td>光华科技</td>\n",
       "      <td>002741</td>\n",
       "      <td>12.39</td>\n",
       "      <td>0.32</td>\n",
       "      <td>16.95</td>\n",
       "      <td>34.06</td>\n",
       "      <td>0.38</td>\n",
       "      <td>...</td>\n",
       "      <td>5.474</td>\n",
       "      <td>2022-12-14</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5.4</td>\n",
       "      <td>2.493</td>\n",
       "      <td>2.493</td>\n",
       "      <td>27.220</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>128029</td>\n",
       "      <td>太阳转债</td>\n",
       "      <td>104.505</td>\n",
       "      <td>太阳纸业</td>\n",
       "      <td>002078</td>\n",
       "      <td>6.56</td>\n",
       "      <td>0.46</td>\n",
       "      <td>8.65</td>\n",
       "      <td>37.80</td>\n",
       "      <td>0.47</td>\n",
       "      <td>...</td>\n",
       "      <td>3.493</td>\n",
       "      <td>2020-12-22</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>7.1</td>\n",
       "      <td>11.998</td>\n",
       "      <td>12.000</td>\n",
       "      <td>73.570</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>128020</td>\n",
       "      <td>水晶转债</td>\n",
       "      <td>98.540</td>\n",
       "      <td>水晶光电</td>\n",
       "      <td>002273</td>\n",
       "      <td>11.40</td>\n",
       "      <td>-0.70</td>\n",
       "      <td>16.00</td>\n",
       "      <td>38.30</td>\n",
       "      <td>0.30</td>\n",
       "      <td>...</td>\n",
       "      <td>4.395</td>\n",
       "      <td>2021-11-17</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11.799</td>\n",
       "      <td>11.800</td>\n",
       "      <td>74.715</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>113509</td>\n",
       "      <td>新泉转债</td>\n",
       "      <td>97.850</td>\n",
       "      <td>新泉股份</td>\n",
       "      <td>603179</td>\n",
       "      <td>13.22</td>\n",
       "      <td>0.38</td>\n",
       "      <td>18.89</td>\n",
       "      <td>39.83</td>\n",
       "      <td>0.23</td>\n",
       "      <td>...</td>\n",
       "      <td>4.942</td>\n",
       "      <td>2022-06-04</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>1</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4.500</td>\n",
       "      <td>4.500</td>\n",
       "      <td>71.540</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>110038</td>\n",
       "      <td>济川转债</td>\n",
       "      <td>106.250</td>\n",
       "      <td>济川药业</td>\n",
       "      <td>600566</td>\n",
       "      <td>29.45</td>\n",
       "      <td>0.82</td>\n",
       "      <td>38.81</td>\n",
       "      <td>40.02</td>\n",
       "      <td>0.04</td>\n",
       "      <td>...</td>\n",
       "      <td>3.384</td>\n",
       "      <td>2020-11-13</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>6.308</td>\n",
       "      <td>8.430</td>\n",
       "      <td>15.921</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>128046</td>\n",
       "      <td>利尔转债</td>\n",
       "      <td>101.611</td>\n",
       "      <td>利尔化学</td>\n",
       "      <td>002258</td>\n",
       "      <td>13.29</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>18.62</td>\n",
       "      <td>42.37</td>\n",
       "      <td>0.41</td>\n",
       "      <td>...</td>\n",
       "      <td>5.315</td>\n",
       "      <td>2022-10-17</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>12.2</td>\n",
       "      <td>8.519</td>\n",
       "      <td>8.520</td>\n",
       "      <td>43.380</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>113009</td>\n",
       "      <td>广汽转债</td>\n",
       "      <td>105.660</td>\n",
       "      <td>广汽集团</td>\n",
       "      <td>601238</td>\n",
       "      <td>10.73</td>\n",
       "      <td>0.66</td>\n",
       "      <td>14.46</td>\n",
       "      <td>42.40</td>\n",
       "      <td>0.15</td>\n",
       "      <td>...</td>\n",
       "      <td>2.578</td>\n",
       "      <td>2020-01-22</td>\n",
       "      <td>AAA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>25.526</td>\n",
       "      <td>41.059</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>113022</td>\n",
       "      <td>浙商转债</td>\n",
       "      <td>106.200</td>\n",
       "      <td>浙商证券</td>\n",
       "      <td>601878</td>\n",
       "      <td>9.28</td>\n",
       "      <td>-2.83</td>\n",
       "      <td>12.46</td>\n",
       "      <td>42.59</td>\n",
       "      <td>-0.30</td>\n",
       "      <td>...</td>\n",
       "      <td>5.715</td>\n",
       "      <td>None</td>\n",
       "      <td>AAA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>11.3</td>\n",
       "      <td>35.000</td>\n",
       "      <td>35.000</td>\n",
       "      <td>30.990</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>123003</td>\n",
       "      <td>蓝思转债</td>\n",
       "      <td>95.200</td>\n",
       "      <td>蓝思科技</td>\n",
       "      <td>300433</td>\n",
       "      <td>6.97</td>\n",
       "      <td>0.14</td>\n",
       "      <td>10.46</td>\n",
       "      <td>42.88</td>\n",
       "      <td>0.21</td>\n",
       "      <td>...</td>\n",
       "      <td>4.455</td>\n",
       "      <td>2021-12-08</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>3</td>\n",
       "      <td>17.5</td>\n",
       "      <td>47.984</td>\n",
       "      <td>48.000</td>\n",
       "      <td>13.540</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>128014</td>\n",
       "      <td>永东转债</td>\n",
       "      <td>96.330</td>\n",
       "      <td>永东股份</td>\n",
       "      <td>002753</td>\n",
       "      <td>8.83</td>\n",
       "      <td>0.23</td>\n",
       "      <td>13.28</td>\n",
       "      <td>44.88</td>\n",
       "      <td>0.03</td>\n",
       "      <td>...</td>\n",
       "      <td>3.811</td>\n",
       "      <td>2021-04-17</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>11.5</td>\n",
       "      <td>3.371</td>\n",
       "      <td>3.400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>110030</td>\n",
       "      <td>格力转债</td>\n",
       "      <td>104.450</td>\n",
       "      <td>格力地产</td>\n",
       "      <td>600185</td>\n",
       "      <td>4.91</td>\n",
       "      <td>-0.81</td>\n",
       "      <td>6.94</td>\n",
       "      <td>47.63</td>\n",
       "      <td>0.03</td>\n",
       "      <td>...</td>\n",
       "      <td>0.499</td>\n",
       "      <td>2018-12-26</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>4.2</td>\n",
       "      <td>4.251</td>\n",
       "      <td>9.800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>110034</td>\n",
       "      <td>九州转债</td>\n",
       "      <td>102.200</td>\n",
       "      <td>九州通</td>\n",
       "      <td>600998</td>\n",
       "      <td>12.26</td>\n",
       "      <td>-0.65</td>\n",
       "      <td>18.32</td>\n",
       "      <td>52.72</td>\n",
       "      <td>0.78</td>\n",
       "      <td>...</td>\n",
       "      <td>2.559</td>\n",
       "      <td>2020-01-15</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>14.993</td>\n",
       "      <td>15.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>128035</td>\n",
       "      <td>大族转债</td>\n",
       "      <td>103.195</td>\n",
       "      <td>大族激光</td>\n",
       "      <td>002008</td>\n",
       "      <td>34.26</td>\n",
       "      <td>0.18</td>\n",
       "      <td>52.30</td>\n",
       "      <td>57.53</td>\n",
       "      <td>-0.10</td>\n",
       "      <td>...</td>\n",
       "      <td>4.619</td>\n",
       "      <td>2022-02-06</td>\n",
       "      <td>AA+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>6.3</td>\n",
       "      <td>22.998</td>\n",
       "      <td>23.000</td>\n",
       "      <td>50.920</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>128037</td>\n",
       "      <td>岩土转债</td>\n",
       "      <td>94.085</td>\n",
       "      <td>中化岩土</td>\n",
       "      <td>002542</td>\n",
       "      <td>4.61</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.03</td>\n",
       "      <td>63.88</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>...</td>\n",
       "      <td>4.723</td>\n",
       "      <td>2022-03-15</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>7.2</td>\n",
       "      <td>6.033</td>\n",
       "      <td>6.037</td>\n",
       "      <td>13.370</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>128032</td>\n",
       "      <td>双环转债</td>\n",
       "      <td>93.235</td>\n",
       "      <td>双环传动</td>\n",
       "      <td>002472</td>\n",
       "      <td>5.55</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9.93</td>\n",
       "      <td>66.82</td>\n",
       "      <td>0.04</td>\n",
       "      <td>...</td>\n",
       "      <td>4.501</td>\n",
       "      <td>2021-12-25</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>26.2</td>\n",
       "      <td>9.999</td>\n",
       "      <td>10.000</td>\n",
       "      <td>49.690</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>128028</td>\n",
       "      <td>赣锋转债</td>\n",
       "      <td>96.700</td>\n",
       "      <td>赣锋锂业</td>\n",
       "      <td>002460</td>\n",
       "      <td>23.82</td>\n",
       "      <td>1.40</td>\n",
       "      <td>42.58</td>\n",
       "      <td>72.86</td>\n",
       "      <td>0.11</td>\n",
       "      <td>...</td>\n",
       "      <td>4.490</td>\n",
       "      <td>2021-12-21</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.278</td>\n",
       "      <td>9.280</td>\n",
       "      <td>53.520</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>128023</td>\n",
       "      <td>亚太转债</td>\n",
       "      <td>92.653</td>\n",
       "      <td>亚太股份</td>\n",
       "      <td>002284</td>\n",
       "      <td>5.53</td>\n",
       "      <td>-2.30</td>\n",
       "      <td>10.34</td>\n",
       "      <td>73.25</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>...</td>\n",
       "      <td>4.455</td>\n",
       "      <td>2021-12-08</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>24.5</td>\n",
       "      <td>9.996</td>\n",
       "      <td>10.000</td>\n",
       "      <td>30.960</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>113014</td>\n",
       "      <td>林洋转债</td>\n",
       "      <td>95.280</td>\n",
       "      <td>林洋能源</td>\n",
       "      <td>601222</td>\n",
       "      <td>4.79</td>\n",
       "      <td>0.42</td>\n",
       "      <td>8.76</td>\n",
       "      <td>74.25</td>\n",
       "      <td>-0.22</td>\n",
       "      <td>...</td>\n",
       "      <td>4.340</td>\n",
       "      <td>2021-10-27</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>35.5</td>\n",
       "      <td>30.000</td>\n",
       "      <td>30.000</td>\n",
       "      <td>78.665</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>113502</td>\n",
       "      <td>嘉澳转债</td>\n",
       "      <td>95.630</td>\n",
       "      <td>嘉澳环保</td>\n",
       "      <td>603822</td>\n",
       "      <td>24.70</td>\n",
       "      <td>-2.02</td>\n",
       "      <td>45.04</td>\n",
       "      <td>74.38</td>\n",
       "      <td>0.14</td>\n",
       "      <td>...</td>\n",
       "      <td>4.375</td>\n",
       "      <td>2021-11-10</td>\n",
       "      <td>AA-</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>10.2</td>\n",
       "      <td>1.848</td>\n",
       "      <td>1.850</td>\n",
       "      <td>59.814</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>127004</td>\n",
       "      <td>模塑转债</td>\n",
       "      <td>93.028</td>\n",
       "      <td>模塑科技</td>\n",
       "      <td>000700</td>\n",
       "      <td>3.87</td>\n",
       "      <td>1.57</td>\n",
       "      <td>7.72</td>\n",
       "      <td>85.57</td>\n",
       "      <td>0.04</td>\n",
       "      <td>...</td>\n",
       "      <td>3.937</td>\n",
       "      <td>2021-06-02</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>25.4</td>\n",
       "      <td>8.136</td>\n",
       "      <td>8.137</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>110031</td>\n",
       "      <td>航信转债</td>\n",
       "      <td>107.180</td>\n",
       "      <td>航天信息</td>\n",
       "      <td>600271</td>\n",
       "      <td>23.15</td>\n",
       "      <td>0.61</td>\n",
       "      <td>41.94</td>\n",
       "      <td>94.17</td>\n",
       "      <td>0.16</td>\n",
       "      <td>...</td>\n",
       "      <td>1.964</td>\n",
       "      <td>2019-06-11</td>\n",
       "      <td>AAA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>5.6</td>\n",
       "      <td>23.995</td>\n",
       "      <td>24.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>128010</td>\n",
       "      <td>顺昌转债</td>\n",
       "      <td>101.058</td>\n",
       "      <td>澳洋顺昌</td>\n",
       "      <td>002245</td>\n",
       "      <td>4.43</td>\n",
       "      <td>-0.45</td>\n",
       "      <td>9.26</td>\n",
       "      <td>111.24</td>\n",
       "      <td>0.55</td>\n",
       "      <td>...</td>\n",
       "      <td>2.578</td>\n",
       "      <td>2020-01-22</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>11.7</td>\n",
       "      <td>5.095</td>\n",
       "      <td>5.100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>128012</td>\n",
       "      <td>辉丰转债</td>\n",
       "      <td>96.901</td>\n",
       "      <td>辉丰股份</td>\n",
       "      <td>002496</td>\n",
       "      <td>2.94</td>\n",
       "      <td>-1.01</td>\n",
       "      <td>7.71</td>\n",
       "      <td>154.13</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>...</td>\n",
       "      <td>2.822</td>\n",
       "      <td>2020-04-21</td>\n",
       "      <td>A+</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>8.443</td>\n",
       "      <td>8.450</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>128013</td>\n",
       "      <td>洪涛转债</td>\n",
       "      <td>96.396</td>\n",
       "      <td>洪涛股份</td>\n",
       "      <td>002325</td>\n",
       "      <td>3.19</td>\n",
       "      <td>-0.93</td>\n",
       "      <td>9.98</td>\n",
       "      <td>201.61</td>\n",
       "      <td>-0.11</td>\n",
       "      <td>...</td>\n",
       "      <td>3.093</td>\n",
       "      <td>2020-07-29</td>\n",
       "      <td>AA</td>\n",
       "      <td></td>\n",
       "      <td>0</td>\n",
       "      <td>30.1</td>\n",
       "      <td>12.000</td>\n",
       "      <td>12.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-06-26 15:04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>162 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      可转债代码 可转债名称    可转债价格  正股名称    正股代码   正股现价  正股涨跌幅  最新转股价     溢价率  可转债涨幅  \\\n",
       "0    127009  冰轮转债  145.750  冰轮环境  000811   8.89  -5.12   5.52   -9.50  -2.54   \n",
       "1    110052  贵广转债  118.080  贵广网络  600996  10.44   3.57   8.13   -8.04   1.23   \n",
       "2    113526  联泰转债  119.170  联泰环保  603797  11.20   1.63   8.72   -7.22   1.15   \n",
       "3    113529  绝味转债  127.770  绝味食品  603517  38.35   4.35  28.51   -5.01   2.95   \n",
       "4    128052  凯龙转债  184.900  凯龙股份  002783  12.83  -3.39   6.77   -2.43  -1.75   \n",
       "5    113533  参林转债  119.000   大参林  603233  44.00   5.19  36.50   -1.29   1.87   \n",
       "6    113507  天马转债  121.470  天马科技  603668   8.98  -1.97   7.32   -0.99  -1.47   \n",
       "7    113511  千禾转债  121.230  千禾味业  603027  22.38   3.47  18.31   -0.82   3.74   \n",
       "8    113523  伟明转债  125.620  伟明环保  603568  22.03  -0.23  17.47   -0.38  -0.03   \n",
       "9    110040  生益转债  128.900  生益科技  600183  14.57   3.19  11.27   -0.29   2.83   \n",
       "10   110050  佳都转债  125.830  佳都科技  600728   9.94  -1.19   7.89   -0.12  -0.02   \n",
       "11   113505  杭电转债  108.730  杭电股份  603618   7.88  -1.13   7.24   -0.10   0.06   \n",
       "12   128038  利欧转债  113.945  利欧股份  002131   1.96   0.00   1.72    0.00  -0.23   \n",
       "13   128024  宁行转债  131.100  宁波银行  002142  23.61  -0.25  18.01    0.01  -0.11   \n",
       "14   123018  溢利转债  107.778   溢多利  300381   8.97  -2.29   8.35    0.32  -0.20   \n",
       "15   113513  安井转债  148.010  安井食品  603345  51.67   3.76  35.08    0.49   4.63   \n",
       "16   128041  盛路转债  143.499  盛路通信  002446   9.81  -0.71   6.88    0.64   0.06   \n",
       "17   113520  百合转债  119.720   梦百合  603313  16.96   1.68  14.28    0.80   1.18   \n",
       "18   113020  桐昆转债  116.800  桐昆股份  601233  14.45   1.33  12.51    1.12   2.18   \n",
       "19   110046  圆通转债  116.190  圆通速递  600233  12.33  -0.32  10.74    1.21   0.11   \n",
       "20   123016  洲明转债  120.000  洲明科技  300232   9.27   0.32   7.82    1.23   0.67   \n",
       "21   110049  海尔转债  120.750  青岛海尔  600690  17.27   1.71  14.55    1.74   1.45   \n",
       "22   113515  高能转债  116.250  高能环境  603588  10.65  -1.84   9.33    1.84  -0.57   \n",
       "23   128057  博彦转债  106.064  博彦科技  002649   9.15   0.66   8.81    2.12   0.40   \n",
       "24   128060  中装转债  101.807  中装建设  002822   6.22  -1.58   6.24    2.13   0.10   \n",
       "25   127003  海印转债  103.530  海印股份  000861   3.07  -9.97   3.03    2.18  -5.54   \n",
       "26   127007  湖广转债  110.200  湖北广电  000665   8.54   0.12   7.92    2.20   0.49   \n",
       "27   113536  三星转债  102.080  三星新材  603578  19.69   0.15  19.75    2.39   0.37   \n",
       "28   128025  特一转债  109.778  特一药业  002728  16.56  -0.36  15.45    2.42   0.25   \n",
       "29   128062  亚药转债  102.250  亚太药业  002370  16.17   0.31  16.25    2.75  -0.32   \n",
       "..      ...   ...      ...   ...     ...    ...    ...    ...     ...    ...   \n",
       "132  113021  中信转债  103.780  中信银行  601998   5.98   0.17   7.45   29.29  -0.01   \n",
       "133  113530  大丰转债   97.770  大丰实业  603081  12.60   0.00  16.76   30.05   0.32   \n",
       "134  128017  金禾转债  105.800  金禾实业  002597  18.63   0.32  22.96   30.39  -0.19   \n",
       "135  113508  新凤转债   99.390   新凤鸣  603225  12.69   0.71  16.83   31.82   0.39   \n",
       "136  110045  海澜转债   98.250  海澜之家  600398   8.91   1.02  12.02   32.54  -0.28   \n",
       "137  123017  寒锐转债   96.720  寒锐钴业  300618  59.29  -0.60  81.49   32.93  -0.18   \n",
       "138  128051  光华转债   98.001  光华科技  002741  12.39   0.32  16.95   34.06   0.38   \n",
       "139  128029  太阳转债  104.505  太阳纸业  002078   6.56   0.46   8.65   37.80   0.47   \n",
       "140  128020  水晶转债   98.540  水晶光电  002273  11.40  -0.70  16.00   38.30   0.30   \n",
       "141  113509  新泉转债   97.850  新泉股份  603179  13.22   0.38  18.89   39.83   0.23   \n",
       "142  110038  济川转债  106.250  济川药业  600566  29.45   0.82  38.81   40.02   0.04   \n",
       "143  128046  利尔转债  101.611  利尔化学  002258  13.29  -0.37  18.62   42.37   0.41   \n",
       "144  113009  广汽转债  105.660  广汽集团  601238  10.73   0.66  14.46   42.40   0.15   \n",
       "145  113022  浙商转债  106.200  浙商证券  601878   9.28  -2.83  12.46   42.59  -0.30   \n",
       "146  123003  蓝思转债   95.200  蓝思科技  300433   6.97   0.14  10.46   42.88   0.21   \n",
       "147  128014  永东转债   96.330  永东股份  002753   8.83   0.23  13.28   44.88   0.03   \n",
       "148  110030  格力转债  104.450  格力地产  600185   4.91  -0.81   6.94   47.63   0.03   \n",
       "149  110034  九州转债  102.200   九州通  600998  12.26  -0.65  18.32   52.72   0.78   \n",
       "150  128035  大族转债  103.195  大族激光  002008  34.26   0.18  52.30   57.53  -0.10   \n",
       "151  128037  岩土转债   94.085  中化岩土  002542   4.61   0.00   8.03   63.88  -0.02   \n",
       "152  128032  双环转债   93.235  双环传动  002472   5.55   0.00   9.93   66.82   0.04   \n",
       "153  128028  赣锋转债   96.700  赣锋锂业  002460  23.82   1.40  42.58   72.86   0.11   \n",
       "154  128023  亚太转债   92.653  亚太股份  002284   5.53  -2.30  10.34   73.25  -0.01   \n",
       "155  113014  林洋转债   95.280  林洋能源  601222   4.79   0.42   8.76   74.25  -0.22   \n",
       "156  113502  嘉澳转债   95.630  嘉澳环保  603822  24.70  -2.02  45.04   74.38   0.14   \n",
       "157  127004  模塑转债   93.028  模塑科技  000700   3.87   1.57   7.72   85.57   0.04   \n",
       "158  110031  航信转债  107.180  航天信息  600271  23.15   0.61  41.94   94.17   0.16   \n",
       "159  128010  顺昌转债  101.058  澳洋顺昌  002245   4.43  -0.45   9.26  111.24   0.55   \n",
       "160  128012  辉丰转债   96.901  辉丰股份  002496   2.94  -1.01   7.71  154.13  -0.15   \n",
       "161  128013  洪涛转债   96.396  洪涛股份  002325   3.19  -0.93   9.98  201.61  -0.11   \n",
       "\n",
       "     ...   剩余时间       回售起始日   评级  下修提示  下调次数 转债剩余占总市值比     剩余规模     发行规模  \\\n",
       "0    ...  5.559  2023-01-14   AA           0       8.8    5.091    5.091   \n",
       "1    ...  5.696  2023-03-05  AA+           0      14.7   16.000   16.000   \n",
       "2    ...  5.581  2023-01-23   AA           0      11.7    3.900    3.900   \n",
       "3    ...  5.712  2023-03-11   AA           0       4.5   10.000   10.000   \n",
       "4    ...  5.493  2022-12-21   AA           0       7.7    3.289    3.289   \n",
       "5    ...  5.773  2023-04-03   AA           0       4.4   10.000   10.000   \n",
       "6    ...  4.814  2022-04-17  AA-           1       2.0    0.599    3.050   \n",
       "7    ...  4.986  2022-06-20  AA-           0       3.4    3.500    3.560   \n",
       "8    ...  5.463  2022-12-10   AA           0       2.6    5.347    6.700   \n",
       "9    ...  4.414        None  AA+           0       4.8   14.812   18.000   \n",
       "10   ...  5.485  2022-12-19   AA           0       5.4    8.747    8.747   \n",
       "11   ...  4.696  2022-03-06   AA           0      14.3    7.767    7.800   \n",
       "12   ...  4.742  2022-03-22   AA           1       1.4    1.811   21.975   \n",
       "13   ...  4.447        None  AAA           0       3.9   49.060  100.000   \n",
       "14   ...  5.490  2022-12-20  AA-           0      18.2    6.650    6.650   \n",
       "15   ...  5.049  2022-07-12  AA-           0       0.1    0.145    5.000   \n",
       "16   ...  5.060  2022-07-17   AA           0       1.0    0.871   10.000   \n",
       "17   ...  5.375  2022-11-08  AA-           0       7.8    4.236    5.100   \n",
       "18   ...  5.405  2022-11-19  AA+           0      14.4   37.806   38.000   \n",
       "19   ...  5.405  2022-11-20  AA+           0      10.4   36.241   36.500   \n",
       "20   ...  5.373  2022-11-07  AA-           0       6.1    5.200    5.480   \n",
       "21   ...  5.482  2022-12-18  AAA           0       2.7   30.075   30.075   \n",
       "22   ...  5.088  2022-07-26   AA           0       9.9    7.093    8.400   \n",
       "23   ...  5.696  2023-03-05  AA-           0      12.0    5.758    5.758   \n",
       "24   ...  5.753  2023-03-27   AA           0      14.1    5.250    5.250   \n",
       "25   ...  2.953  2020-06-08   AA           2      14.1    9.416   11.110   \n",
       "26   ...  5.011  2022-06-28  AA+           1      22.7   13.214   17.336   \n",
       "27   ...  5.932  2023-05-31   AA           0      10.9    1.920    1.920   \n",
       "28   ...  4.449  2021-12-06  AA-           1      10.2    3.394    3.540   \n",
       "29   ...  5.773  2023-04-03   AA           0      11.1    9.650    9.650   \n",
       "..   ...    ...         ...  ...   ...   ...       ...      ...      ...   \n",
       "132  ...  5.690        None  AAA           0      13.7  400.000  400.000   \n",
       "133  ...  5.753  2023-03-27   AA           0      12.4    6.300    6.300   \n",
       "134  ...  4.353  2022-11-01   AA           0       5.8    6.000    6.000   \n",
       "135  ...  4.836  2022-04-26   AA           0      14.2   21.524   21.530   \n",
       "136  ...  5.052  2022-07-13  AA+           0       7.6   29.994   30.000   \n",
       "137  ...  5.408  2022-11-20  AA-           0       3.9    4.400    4.400   \n",
       "138  ...  5.474  2022-12-14  AA-           0       5.4    2.493    2.493   \n",
       "139  ...  3.493  2020-12-22  AA+           0       7.1   11.998   12.000   \n",
       "140  ...  4.395  2021-11-17   AA           1      12.0   11.799   11.800   \n",
       "141  ...  4.942  2022-06-04   AA           1      15.0    4.500    4.500   \n",
       "142  ...  3.384  2020-11-13   AA           0       2.6    6.308    8.430   \n",
       "143  ...  5.315  2022-10-17   AA           0      12.2    8.519    8.520   \n",
       "144  ...  2.578  2020-01-22  AAA           0       2.3   25.526   41.059   \n",
       "145  ...  5.715        None  AAA           0      11.3   35.000   35.000   \n",
       "146  ...  4.455  2021-12-08  AA+           3      17.5   47.984   48.000   \n",
       "147  ...  3.811  2021-04-17  AA-           0      11.5    3.371    3.400   \n",
       "148  ...  0.499  2018-12-26   AA           0       4.2    4.251    9.800   \n",
       "149  ...  2.559  2020-01-15  AA+           0       6.5   14.993   15.000   \n",
       "150  ...  4.619  2022-02-06  AA+           0       6.3   22.998   23.000   \n",
       "151  ...  4.723  2022-03-15   AA           0       7.2    6.033    6.037   \n",
       "152  ...  4.501  2021-12-25   AA           0      26.2    9.999   10.000   \n",
       "153  ...  4.490  2021-12-21   AA           0       3.0    9.278    9.280   \n",
       "154  ...  4.455  2021-12-08   AA           0      24.5    9.996   10.000   \n",
       "155  ...  4.340  2021-10-27   AA           0      35.5   30.000   30.000   \n",
       "156  ...  4.375  2021-11-10  AA-           0      10.2    1.848    1.850   \n",
       "157  ...  3.937  2021-06-02   AA           0      25.4    8.136    8.137   \n",
       "158  ...  1.964  2019-06-11  AAA           0       5.6   23.995   24.000   \n",
       "159  ...  2.578  2020-01-22   AA           0      11.7    5.095    5.100   \n",
       "160  ...  2.822  2020-04-21   A+           0      19.0    8.443    8.450   \n",
       "161  ...  3.093  2020-07-29   AA           0      30.1   12.000   12.000   \n",
       "\n",
       "      股东配售率              更新日期  \n",
       "0    44.230  2019-06-26 15:04  \n",
       "1    32.835  2019-06-26 15:04  \n",
       "2    77.340  2019-06-26 15:04  \n",
       "3    55.430  2019-06-26 15:04  \n",
       "4    19.050  2019-06-26 15:04  \n",
       "5    40.200  2019-06-26 15:04  \n",
       "6    32.260  2019-06-26 15:04  \n",
       "7    11.540  2019-06-26 15:04  \n",
       "8    83.350  2019-06-26 15:04  \n",
       "9    81.241  2019-06-26 15:04  \n",
       "10   14.080  2019-06-26 15:04  \n",
       "11   20.430  2019-06-26 15:04  \n",
       "12   26.480  2019-06-26 15:04  \n",
       "13   79.110  2019-06-26 15:04  \n",
       "14   35.630  2019-06-26 15:04  \n",
       "15   56.760  2019-06-26 15:04  \n",
       "16   13.900  2019-06-26 15:04  \n",
       "17   56.660  2019-06-26 15:04  \n",
       "18   43.250  2019-06-26 15:04  \n",
       "19   39.350  2019-06-26 15:04  \n",
       "20   33.980  2019-06-26 15:04  \n",
       "21   60.100  2019-06-26 15:04  \n",
       "22   46.740  2019-06-26 15:04  \n",
       "23   16.060  2019-06-26 15:04  \n",
       "24   32.910  2019-06-26 15:04  \n",
       "25      NaN  2019-06-26 15:04  \n",
       "26   16.550  2019-06-26 15:04  \n",
       "27   35.470  2019-06-26 15:04  \n",
       "28   74.250  2019-06-26 15:04  \n",
       "29   29.780  2019-06-26 15:04  \n",
       "..      ...               ...  \n",
       "132  73.880  2019-06-26 15:04  \n",
       "133  23.030  2019-06-26 15:04  \n",
       "134  89.139  2019-06-26 15:04  \n",
       "135  36.950  2019-06-26 15:04  \n",
       "136  54.100  2019-06-26 15:04  \n",
       "137   5.510  2019-06-26 15:04  \n",
       "138  27.220  2019-06-26 15:04  \n",
       "139  73.570  2019-06-26 15:04  \n",
       "140  74.715  2019-06-26 15:04  \n",
       "141  71.540  2019-06-26 15:04  \n",
       "142  15.921  2019-06-26 15:04  \n",
       "143  43.380  2019-06-26 15:04  \n",
       "144     NaN  2019-06-26 15:04  \n",
       "145  30.990  2019-06-26 15:04  \n",
       "146  13.540  2019-06-26 15:04  \n",
       "147     NaN  2019-06-26 15:04  \n",
       "148     NaN  2019-06-26 15:04  \n",
       "149     NaN  2019-06-26 15:04  \n",
       "150  50.920  2019-06-26 15:04  \n",
       "151  13.370  2019-06-26 15:04  \n",
       "152  49.690  2019-06-26 15:04  \n",
       "153  53.520  2019-06-26 15:04  \n",
       "154  30.960  2019-06-26 15:04  \n",
       "155  78.665  2019-06-26 15:04  \n",
       "156  59.814  2019-06-26 15:04  \n",
       "157     NaN  2019-06-26 15:04  \n",
       "158     NaN  2019-06-26 15:04  \n",
       "159     NaN  2019-06-26 15:04  \n",
       "160     NaN  2019-06-26 15:04  \n",
       "161     NaN  2019-06-26 15:04  \n",
       "\n",
       "[162 rows x 25 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "16.649431205484024"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ret"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-16-ee45f72a95a0>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      6\u001b[0m     \u001b[0md\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcurrent\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstrftime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'%Y-%m-%d'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m     \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 8\u001b[0;31m         \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_sql\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'tb_jsl_{}'\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mformat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0md\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mcon\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcon\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      9\u001b[0m     \u001b[0;32mexcept\u001b[0m \u001b[0mException\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     10\u001b[0m         \u001b[0;32mcontinue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/io/sql.py\u001b[0m in \u001b[0;36mread_sql\u001b[0;34m(sql, con, index_col, coerce_float, params, parse_dates, columns, chunksize)\u001b[0m\n\u001b[1;32m    387\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    388\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0m_is_table_name\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 389\u001b[0;31m         \u001b[0mpandas_sql\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmeta\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreflect\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0monly\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0msql\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    390\u001b[0m         return pandas_sql.read_table(\n\u001b[1;32m    391\u001b[0m             \u001b[0msql\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindex_col\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mindex_col\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcoerce_float\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcoerce_float\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/sql/schema.py\u001b[0m in \u001b[0;36mreflect\u001b[0;34m(self, bind, schema, views, only, extend_existing, autoload_replace, resolve_fks, **dialect_kwargs)\u001b[0m\n\u001b[1;32m   4197\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4198\u001b[0m             available = util.OrderedSet(\n\u001b[0;32m-> 4199\u001b[0;31m                 \u001b[0mbind\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtable_names\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mschema\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mconnection\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mconn\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   4200\u001b[0m             )\n\u001b[1;32m   4201\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mviews\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py\u001b[0m in \u001b[0;36mtable_names\u001b[0;34m(self, schema, connection)\u001b[0m\n\u001b[1;32m   2241\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mschema\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2242\u001b[0m                 \u001b[0mschema\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdialect\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdefault_schema_name\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2243\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdialect\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_table_names\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mconn\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mschema\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2244\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2245\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mhas_table\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtable_name\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mschema\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<string>\u001b[0m in \u001b[0;36mget_table_names\u001b[0;34m(self, connection, schema, **kw)\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py\u001b[0m in \u001b[0;36mcache\u001b[0;34m(fn, self, con, *args, **kw)\u001b[0m\n\u001b[1;32m     41\u001b[0m     \u001b[0minfo_cache\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mkw\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"info_cache\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     42\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0minfo_cache\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 43\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mfn\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcon\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkw\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     44\u001b[0m     key = (\n\u001b[1;32m     45\u001b[0m         \u001b[0mfn\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__name__\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/dialects/mysql/base.py\u001b[0m in \u001b[0;36mget_table_names\u001b[0;34m(self, connection, schema, **kw)\u001b[0m\n\u001b[1;32m   2437\u001b[0m             rp = connection.execute(\n\u001b[1;32m   2438\u001b[0m                 \u001b[0;34m\"SHOW FULL TABLES FROM %s\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2439\u001b[0;31m                 \u001b[0;34m%\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0midentifier_preparer\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mquote_identifier\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcurrent_schema\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2440\u001b[0m             )\n\u001b[1;32m   2441\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py\u001b[0m in \u001b[0;36mexecute\u001b[0;34m(self, object_, *multiparams, **params)\u001b[0m\n\u001b[1;32m    980\u001b[0m         \"\"\"\n\u001b[1;32m    981\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mobject_\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mutil\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mstring_types\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 982\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_execute_text\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mobject_\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmultiparams\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparams\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    983\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    984\u001b[0m             \u001b[0mmeth\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mobject_\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_execute_on_connection\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py\u001b[0m in \u001b[0;36m_execute_text\u001b[0;34m(self, statement, multiparams, params)\u001b[0m\n\u001b[1;32m   1153\u001b[0m             \u001b[0mparameters\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1154\u001b[0m             \u001b[0mstatement\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1155\u001b[0;31m             \u001b[0mparameters\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1156\u001b[0m         )\n\u001b[1;32m   1157\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_has_events\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_has_events\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py\u001b[0m in \u001b[0;36m_execute_context\u001b[0;34m(self, dialect, constructor, statement, parameters, *args)\u001b[0m\n\u001b[1;32m   1246\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mBaseException\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1247\u001b[0m             self._handle_dbapi_exception(\n\u001b[0;32m-> 1248\u001b[0;31m                 \u001b[0me\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstatement\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparameters\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcursor\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcontext\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1249\u001b[0m             )\n\u001b[1;32m   1250\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py\u001b[0m in \u001b[0;36m_handle_dbapi_exception\u001b[0;34m(self, e, statement, parameters, cursor, context)\u001b[0m\n\u001b[1;32m   1466\u001b[0m                 \u001b[0mutil\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mraise_from_cause\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msqlalchemy_exception\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mexc_info\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1467\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1468\u001b[0;31m                 \u001b[0mutil\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreraise\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0mexc_info\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1469\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1470\u001b[0m         \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/util/compat.py\u001b[0m in \u001b[0;36mreraise\u001b[0;34m(tp, value, tb, cause)\u001b[0m\n\u001b[1;32m    127\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__traceback__\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mtb\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    128\u001b[0m             \u001b[0;32mraise\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwith_traceback\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtb\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 129\u001b[0;31m         \u001b[0;32mraise\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    130\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    131\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mu\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/base.py\u001b[0m in \u001b[0;36m_execute_context\u001b[0;34m(self, dialect, constructor, statement, parameters, *args)\u001b[0m\n\u001b[1;32m   1242\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0mevt_handled\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1243\u001b[0m                     self.dialect.do_execute(\n\u001b[0;32m-> 1244\u001b[0;31m                         \u001b[0mcursor\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstatement\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparameters\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcontext\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1245\u001b[0m                     )\n\u001b[1;32m   1246\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mBaseException\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/sqlalchemy/engine/default.py\u001b[0m in \u001b[0;36mdo_execute\u001b[0;34m(self, cursor, statement, parameters, context)\u001b[0m\n\u001b[1;32m    550\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    551\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mdo_execute\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcursor\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstatement\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparameters\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcontext\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 552\u001b[0;31m         \u001b[0mcursor\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstatement\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparameters\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    553\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    554\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mdo_execute_no_params\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcursor\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstatement\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mcontext\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py\u001b[0m in \u001b[0;36mexecute\u001b[0;34m(self, query, args)\u001b[0m\n\u001b[1;32m    168\u001b[0m         \u001b[0mquery\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mmogrify\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mquery\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0margs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    169\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 170\u001b[0;31m         \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_query\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mquery\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    171\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_executed\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mquery\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    172\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/cursors.py\u001b[0m in \u001b[0;36m_query\u001b[0;34m(self, q)\u001b[0m\n\u001b[1;32m    326\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_last_executed\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mq\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    327\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_clear_result\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 328\u001b[0;31m         \u001b[0mconn\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mquery\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mq\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    329\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_do_get_result\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    330\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrowcount\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/connections.py\u001b[0m in \u001b[0;36mquery\u001b[0;34m(self, sql, unbuffered)\u001b[0m\n\u001b[1;32m    514\u001b[0m                 \u001b[0msql\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0msql\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mencode\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mencoding\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'surrogateescape'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    515\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_execute_command\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mCOMMAND\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mCOM_QUERY\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msql\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 516\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_affected_rows\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_read_query_result\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0munbuffered\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0munbuffered\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    517\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_affected_rows\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    518\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/connections.py\u001b[0m in \u001b[0;36m_read_query_result\u001b[0;34m(self, unbuffered)\u001b[0m\n\u001b[1;32m    725\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    726\u001b[0m             \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mMySQLResult\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 727\u001b[0;31m             \u001b[0mresult\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    728\u001b[0m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_result\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    729\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mserver_status\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/connections.py\u001b[0m in \u001b[0;36mread\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1064\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1065\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1066\u001b[0;31m             \u001b[0mfirst_packet\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconnection\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_read_packet\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1067\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1068\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mfirst_packet\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_ok_packet\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/connections.py\u001b[0m in \u001b[0;36m_read_packet\u001b[0;34m(self, packet_type)\u001b[0m\n\u001b[1;32m    654\u001b[0m         \u001b[0mbuff\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34mb''\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    655\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 656\u001b[0;31m             \u001b[0mpacket_header\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_read_bytes\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    657\u001b[0m             \u001b[0;31m#if DEBUG: dump_packet(packet_header)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    658\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pymysql/connections.py\u001b[0m in \u001b[0;36m_read_bytes\u001b[0;34m(self, num_bytes)\u001b[0m\n\u001b[1;32m    688\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    689\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 690\u001b[0;31m                 \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_rfile\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnum_bytes\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    691\u001b[0m                 \u001b[0;32mbreak\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    692\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mIOError\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mOSError\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/anaconda3/lib/python3.6/socket.py\u001b[0m in \u001b[0;36mreadinto\u001b[0;34m(self, b)\u001b[0m\n\u001b[1;32m    584\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    585\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 586\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sock\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrecv_into\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mb\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    587\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    588\u001b[0m                 \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_timeout_occurred\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "# 02-25 start\n",
    "start = datetime.datetime(2019,2,25)\n",
    "current = start\n",
    "result={}\n",
    "while current<datetime.datetime.now():\n",
    "    d=current.strftime('%Y-%m-%d')\n",
    "    try:\n",
    "        df = pd.read_sql('tb_jsl_{}'.format(d),con=con)\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        continue\n",
    "    else:\n",
    "        df=df[df['可转债价格']>0] # 去除停牌\n",
    "        ret = df['可转债价格'].std()\n",
    "        result[d]=ret\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
